Release 10.1A: OpenEdge Data Management:
Database Administration

PROUTIL IDXCHECK qualifier

Checks database indexes to determine whether an index is corrupt, and if it is, diagnoses the problem.

Syntax

proutil db-name -C idxcheck  [ all |table [owner-name.]table-name |      area area-name | schema schema-owner]

Parameters

db-name

Specifies the database whose index you are checking.

all

Specifies that you want to check all your indexes.

table [owner-name.]table-name

Specifies that you want to check the indexes defined for the named table.

area area-name

Specifies that you want to check all the indexes defined in the named area.

schema schema-owner

Specifies that you want to check all the indexes owned by the named schema-owner.

If you do not specify all, table, area, or schema, the following menu appears:

Index Check Utility       ===================       Select one of the following:       All (a/A) - Check all the indexes       Some (s/S) - Check only some of the indexes       By Area (r/R) - Check indexes in selected areas       By Schema (c/C) - Check indexes by schema owners       By Table (t/T) - Check indexes in selected tables       Quit (q/Q) - Quit, do not Check       Enter your selection:

Table 20–3 describes the options.

Table 20–3: PROUTIL IDXCHECK options

Option	Action
All	Checks all the indexes.
By Area	Prompts you for the area containing the indexes you want to check.
By Schema	Prompts you for the schema owner of the indexes you want to check.
By Table	Prompts you for the table containing the indexes you want to check.
Some	Prompts you for the indexes you want to check.
Quit	Quits without checking any indexes.

PROUTIL IDXCHECK lets you know whether you have to perform an index rebuild before actually running PROUTIL IDXBUILD. IDXCHECK performs the following operations for each index it checks:

Reads the contents of the index and the contents of the file, verifies that all the values in the records are indexed, and verifies that each value in the index is in the associated record.
Performs various checks on the data structures in the index to verify that there is no corruption.

IF PROUTIL IDXCHECK completes successfully, it ensures that all FIND, CAN-FIND, GET, FOR EACH, and PRESELECT statements that use those indexes work correctly. If errors result, the problem index might produce unexpected results with those statements.

Notes

When PROUTIL IDXCHECK finds any corruption, it displays error messages. If error messages appear, save the database and the output messages for analysis by Technical Support, back up your database, and then run PROUTIL IDXBUILD.
IDXCHECK displays error and warning messages on the screen and logs them in the log file. It also displays and logs a success or failure indication, along with the number of errors and warnings issued.
IDXCHECK might also display warning messages. Although these messages indicate that some condition is a problem, the index is still valid. Check the log file for details.